/* ---------------------------------------------------------------------- */
/* Script generated with: DeZign for Databases v4.1.3                     */
/* Target DBMS:           MS SQL Server 2005                              */
/* Project file:          crime1.dez                                      */
/* Project name:                                                          */
/* Author:                                                                */
/* Script type:           Database drop script                            */
/* Created on:            2011-08-17 19:28                                */
/* ---------------------------------------------------------------------- */


/* ---------------------------------------------------------------------- */
/* Drop foreign key constraints                                           */
/* ---------------------------------------------------------------------- */

ALTER TABLE [SYS_USER] DROP CONSTRAINT [ROLE_SYS_USER]
GO

ALTER TABLE [ROLE_MENU] DROP CONSTRAINT [ROLE_ROLE_MENU]
GO

ALTER TABLE [ROLE_MENU] DROP CONSTRAINT [SYS_MENU_ROLE_MENU]
GO

ALTER TABLE [COMPLAINT_REG] DROP CONSTRAINT [SYS_USER_COMPLAINT_REG]
GO

ALTER TABLE [CRIMINAL_REG] DROP CONSTRAINT [SYS_USER_CRIMINAL_REG]
GO

ALTER TABLE [CRIME_DETAIL] DROP CONSTRAINT [CRIMINAL_REG_CRIME_DETAIL]
GO

ALTER TABLE [CRIME_DETAIL] DROP CONSTRAINT [COMPLAINT_REG_CRIME_DETAIL]
GO

ALTER TABLE [CRIME_DETAIL] DROP CONSTRAINT [HISTORY_CRIME_DETAIL]
GO

ALTER TABLE [POSTMOTEM] DROP CONSTRAINT [HISTORY_POSTMOTEM]
GO

ALTER TABLE [CRAME] DROP CONSTRAINT [CRIME_DETAIL_CRAME]
GO

ALTER TABLE [CRAME] DROP CONSTRAINT [LIST_CRIME_CRAME]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "SYS_USER"                                                  */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [SYS_USER] DROP CONSTRAINT [PK_SYS_USER]
GO

/* Drop table */

DROP TABLE [SYS_USER]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "ROLE"                                                      */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [ROLE] DROP CONSTRAINT [PK_ROLE]
GO

/* Drop table */

DROP TABLE [ROLE]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "ROLE_MENU"                                                 */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [ROLE_MENU] DROP CONSTRAINT [PK_ROLE_MENU]
GO

/* Drop table */

DROP TABLE [ROLE_MENU]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "SYS_MENU"                                                  */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [SYS_MENU] DROP CONSTRAINT [PK_SYS_MENU]
GO

/* Drop table */

DROP TABLE [SYS_MENU]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "COMPLAINT_REG"                                             */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [COMPLAINT_REG] DROP CONSTRAINT [PK_COMPLAINT_REG]
GO

/* Drop table */

DROP TABLE [COMPLAINT_REG]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "CRIMINAL_REG"                                              */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [CRIMINAL_REG] DROP CONSTRAINT [PK_CRIMINAL_REG]
GO

/* Drop table */

DROP TABLE [CRIMINAL_REG]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "CRIME_DETAIL"                                              */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [CRIME_DETAIL] DROP CONSTRAINT [PK_CRIME_DETAIL]
GO

/* Drop table */

DROP TABLE [CRIME_DETAIL]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "POSTMOTEM"                                                 */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [POSTMOTEM] DROP CONSTRAINT [PK_POSTMOTEM]
GO

/* Drop table */

DROP TABLE [POSTMOTEM]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "HISTORY"                                                   */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [HISTORY] DROP CONSTRAINT [PK_HISTORY]
GO

/* Drop table */

DROP TABLE [HISTORY]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "LIST_CRIME"                                                */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [LIST_CRIME] DROP CONSTRAINT [PK_LIST_CRIME]
GO

/* Drop table */

DROP TABLE [LIST_CRIME]
GO

/* ---------------------------------------------------------------------- */
/* Drop table "CRAME"                                                     */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE [CRAME] DROP CONSTRAINT [PK_CRAME]
GO

/* Drop table */

DROP TABLE [CRAME]
GO
